Deletes the current row from a recordset. When a row is deleted, the rows after it move up to fill the empty index. If the last row is deleted, the active row is at RecordsetEOF.
Note: To delete a row from a Microsoft Access, Oracle, or SQL Server datasheet, a primary key must be defined. To delete a row from a Microsoft Excel datasheet, Excel must be installed on the computer running the script. If a primary key is not defined or Excel is not installed, QA Wizard Pro opens the recordset as read-only.
Syntax
DeleteRecordsetRow(Recordset)
Arguments
Argument | Description |
---|---|
Recordset | Recordset name to delete the row from. Must be opened with OpenRecordset or OpenRecordsetQuery. |
Example
bugs = OpenRecordset("WysiCorp Bugs")
NextRow(bugs)
DeleteRecordsetRow(bugs)